<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  

  
  <title>MySQL数据库操作（一）——DDL、DML、DCL | 海晨忆的博客</title>
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
  
  
  
  <meta name="description" content="MySQL:&amp;emsp;&amp;emsp;启动：net start mysql &amp;emsp;&amp;emsp;停止：net stop mysql &amp;emsp;&amp;emsp;登录：mysql -u root -p 例如：mysql -uroot -p123 -hlocalhost &amp;emsp;&amp;emsp;退出：exit或者quit">
<meta property="og:type" content="article">
<meta property="og:title" content="MySQL数据库操作（一）——DDL、DML、DCL">
<meta property="og:url" content="https://haichenyi.com/2018/10/11/MySQL数据库操作（一）——DDL、DML、DCL/index.html">
<meta property="og:site_name" content="海晨忆的博客">
<meta property="og:description" content="MySQL:&amp;emsp;&amp;emsp;启动：net start mysql &amp;emsp;&amp;emsp;停止：net stop mysql &amp;emsp;&amp;emsp;登录：mysql -u root -p 例如：mysql -uroot -p123 -hlocalhost &amp;emsp;&amp;emsp;退出：exit或者quit">
<meta property="og:locale" content="zh-Hans">
<meta property="og:updated_time" content="2018-10-11T15:03:23.646Z">
<meta name="twitter:card" content="summary">
<meta name="twitter:title" content="MySQL数据库操作（一）——DDL、DML、DCL">
<meta name="twitter:description" content="MySQL:&amp;emsp;&amp;emsp;启动：net start mysql &amp;emsp;&amp;emsp;停止：net stop mysql &amp;emsp;&amp;emsp;登录：mysql -u root -p 例如：mysql -uroot -p123 -hlocalhost &amp;emsp;&amp;emsp;退出：exit或者quit">
  
    <link rel="alternate" href="/atom.xml" title="海晨忆的博客" type="application/atom+xml">
  
  
    <link rel="icon" href="/uploads/artistic_image/head.jpg">
  
  
    <link href="//fonts.googleapis.com/css?family=Source+Code+Pro" rel="stylesheet" type="text/css">
  
  <link rel="stylesheet" href="/css/style.css">
  <link rel="stylesheet" href="/css/highlight.css">
  <script>
  let antiquityStorage = window.sessionStorage.getItem('antiquitySessionStorage');
  if (antiquityStorage == '' || antiquityStorage == null) {
    var antiquityLoader = '<div id="loaderbox"><div class="loader"><div class="load-roll"><div class="load-top"></div><div class="load-right"></div><div class="load-bottom"></div></div></div></div>';
    document.write(antiquityLoader);
    document.body.style.overflow = 'hidden'
  }
  </script>
</head>

<body>
  <div id="fullpage" class="mobile-nav-right">
    
      <div id="wrapper" style="background-image: url(/uploads/artistic_image/bg.jpg)" title="背景图片来自网络">
    
    
      <header id="header">
  <div id="nav-toggle" class="nav-toggle"></div>
  <div class="head-box global-width">
    <nav class="nav-box nav-right">
      
        <a class="nav-item" href="/" title
        
        >首页</a>
      
        <a class="nav-item" href="/archives" title
        
        >归档</a>
      
        <a class="nav-item" href="/about" title
        
        >简历</a>
      
    </nav>
  </div>
</header>
      <div id="middlecontent" title class="global-width sidebar-left">
        <section id="main"><article id="post-MySQL数据库操作（一）——DDL、DML、DCL" class="article global-container article-type-post" itemscope itemprop="blogPost">
  
    <header class="article-header">
      
  
    <h1 class="article-title" itemprop="name">
      MySQL数据库操作（一）——DDL、DML、DCL
    </h1>
  

    </header>
  
  <div class="article-meta">
    <a href="/2018/10/11/MySQL数据库操作（一）——DDL、DML、DCL/" class="article-date">
  <time datetime="2018-10-11T14:49:35.000Z" itemprop="datePublished">2018-10-11</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/categories/数据库-MySQL/">数据库 -MySQL</a>
  </div>

    
  </div>
  
    <span id="busuanzi_container_page_pv">
      本文总阅读量<span id="busuanzi_value_page_pv"></span>次
    </span>
  

  <div class="article-inner">
    
    <div class="article-content article-content-cloud doorframe mac" itemprop="articleBody">
      
        <h3 id="MySQL"><a href="#MySQL" class="headerlink" title="MySQL:"></a>MySQL:</h3><p>&emsp;&emsp;<strong>启动：</strong><code>net start mysql</code></p>
<p>&emsp;&emsp;<strong>停止：</strong><code>net stop mysql</code></p>
<p>&emsp;&emsp;<strong>登录：</strong><code>mysql -u root -p</code> 例如：mysql -uroot -p123 -hlocalhost</p>
<p>&emsp;&emsp;<strong>退出：</strong><code>exit或者quit</code></p>
<a id="more"></a>
<h3 id="DDL操作："><a href="#DDL操作：" class="headerlink" title="DDL操作："></a>DDL操作：</h3><p>&emsp;&emsp;加上if exists或者if not exists：都是如果存在，或者如果不存在，就不做相关操作</p>
<p>&emsp;&emsp;<strong>查询当前有哪些数据库：</strong><code>show databases;</code></p>
<p>&emsp;&emsp;<strong>创建数据库：</strong><code>CREATE DATABASE if not exists 数据库的名字 CHARSET=utf8;</code>例如：CREATE DATABASE if not exists employee CHARSET=utf8;创建一个编码为utf-8的employee数据库。不存在就创建，存在就不管。</p>
<p>&emsp;&emsp;<strong>删除数据库：</strong><code>DRAP DATABASE if exists 数据库名称;</code>例如：DRAP DATABASE if exists employee;删除employee数据库，如果存在就删除，不存在就不管。</p>
<p>&emsp;&emsp;<strong>修改数据库编码方式：</strong><code>ALTER DATABASE 数据库名称 CHARACTER SET utf8;</code></p>
<p>&emsp;&emsp;<strong>切换数据库：</strong><code>use 数据库名称;</code></p>
<p>&emsp;&emsp;<strong>创建表：</strong><code>CREATE TABLE if not exists 表名(列名 列类型,...,列名 列类型);</code> </p>
<div class="highlight-box"autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false" contenteditable="true"data-rel="PLAIN"><figure class="iseeu highlight /plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br><span class="line">11</span><br></pre></td><td class="code"><pre><span class="line">CREATE TABLE if noe exists t_stu(</span><br><span class="line"></span><br><span class="line">        stu_num char(11),</span><br><span class="line"></span><br><span class="line">        stu_name varchar(50),</span><br><span class="line"></span><br><span class="line">        stu_age int,</span><br><span class="line"></span><br><span class="line">        stu_sex varchar(10)</span><br><span class="line"></span><br><span class="line">        );</span><br></pre></td></tr></table></figure></div>
<p>&emsp;&emsp;<strong>显示当前数据库包含的表：</strong><code>show tables;</code></p>
<p>&emsp;&emsp;<strong>显示当前表结构：</strong><code>desc 表名称;</code></p>
<p>&emsp;&emsp;<strong>删除表：</strong><code>drop table 表名称;</code></p>
<p>&emsp;&emsp;<strong>新增列：</strong><code>alter table 表名 add(列名 列类型,...,列名 列类型);</code></p>
<div class="highlight-box"autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false" contenteditable="true"data-rel="PLAIN"><figure class="iseeu highlight /plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br></pre></td><td class="code"><pre><span class="line">alter table t_stu add(</span><br><span class="line"></span><br><span class="line">        stu_address varchar(100),</span><br><span class="line"></span><br><span class="line">        stu_phone char(11)</span><br><span class="line"></span><br><span class="line">        );</span><br></pre></td></tr></table></figure></div>
<p>&emsp;&emsp;<strong>修改列类型：</strong><code>alter table 表名 modify 列名 列新类型;</code></p>
<div class="highlight-box"autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false" contenteditable="true"data-rel="PLAIN"><figure class="iseeu highlight /plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">alter table t_stu modify stu_address varchar(50);</span><br></pre></td></tr></table></figure></div>
<p>&emsp;&emsp;<strong>修改列名：</strong><code>alter table 表名 change 原始列名 新列名 列类型;</code></p>
<div class="highlight-box"autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false" contenteditable="true"data-rel="PLAIN"><figure class="iseeu highlight /plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">alter table t_stu change stu_address stu_addr varchar(100);</span><br></pre></td></tr></table></figure></div>
<p>&emsp;&emsp;<strong>删除列：</strong><code>alter table 表名 drop 列名;</code><br><div class="highlight-box"autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false" contenteditable="true"data-rel="PLAIN"><figure class="iseeu highlight /plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">alter table t_stu drop stu_address;</span><br></pre></td></tr></table></figure></div></p>
<p>&emsp;&emsp;<strong>修改表名：</strong><code>alter table 原始表名 rename to 新表名;</code></p>
<h3 id="DML操作："><a href="#DML操作：" class="headerlink" title="DML操作："></a>DML操作：</h3><p>为了好操作，先用一下查询的命令，查询表的所有记录： select * from 表名;</p>
<p>&emsp;&emsp;<strong>插入一行记录：</strong><code>INSERT INTO 表名 (列名,...,列名)VALUES(列值,...,列值);</code><br><div class="highlight-box"autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false" contenteditable="true"data-rel="PLAIN"><figure class="iseeu highlight /plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br></pre></td><td class="code"><pre><span class="line">INSERT INTO t_stu(</span><br><span class="line"></span><br><span class="line">        stu_num,stu_name,stu_age,stu_sex,stu_phone</span><br><span class="line">        </span><br><span class="line">        )VALUES(</span><br><span class="line">        </span><br><span class="line">        &apos;test_num_001&apos;,&apos;张三&apos;,18,&apos;man&apos;,&apos;13888888888&apos;</span><br><span class="line">        </span><br><span class="line">        );</span><br></pre></td></tr></table></figure></div></p>
<p>&emsp;&emsp;<strong>修改所有数据：</strong><code>update 表名 set 列名=列值,...,列名=列值;</code></p>
<div class="highlight-box"autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false" contenteditable="true"data-rel="PLAIN"><figure class="iseeu highlight /plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">update t_stu set name=&apos;wangwu&apos;;</span><br></pre></td></tr></table></figure></div>
<p>&emsp;&emsp;<strong>修改数据(单个条件)：</strong><code>update 表名 set 列名=列值,...,列名=列值 where 列名=列值;</code></p>
<div class="highlight-box"autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false" contenteditable="true"data-rel="PLAIN"><figure class="iseeu highlight /plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">update t_stu set stu_name=&apos;zhangsan&apos; where stu_num=&apos;testNum_00001&apos;;</span><br></pre></td></tr></table></figure></div>
<p>&emsp;&emsp;<strong>修改数据(多个条件)：</strong><code>update 表名 set 列名=列值,...,列名=列值 where 列名=列值 or 列名=列值;</code><br><div class="highlight-box"autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false" contenteditable="true"data-rel="PLAIN"><figure class="iseeu highlight /plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br></pre></td><td class="code"><pre><span class="line">//or,或者</span><br><span class="line">update t_stu set stu_age=28 where stu_num=&apos;testNum_0001&apos; or stu_name=&apos;zhangliu&apos;;</span><br><span class="line">//and，并且</span><br><span class="line">update t_stu set stu_age=28 where stu_age&gt;=25 and stu_age&lt;=30;</span><br><span class="line">//between...and...在什么区间内</span><br><span class="line">update t_stu set stu_age=28 where stu_age between 25 and 30;</span><br><span class="line">//in(...)</span><br><span class="line">update t_stu set stu_age=28 where stu_name  in (&apos;zhangsan&apos;,&apos;lisi&apos;);</span><br><span class="line">//is null，是null。不能是stu_name=null</span><br><span class="line">update t_stu set stu_age=28 where stu_name  is null;</span><br></pre></td></tr></table></figure></div></p>
<p>&emsp;&emsp;<strong>删除记录：</strong><code>DELETE FROM 表名 where ...;</code><br><div class="highlight-box"autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false" contenteditable="true"data-rel="PLAIN"><figure class="iseeu highlight /plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">//这里where后面的条件跟前面的update是一样的写法</span><br><span class="line">DELETE FROM t_stu where stu_age = 28;</span><br></pre></td></tr></table></figure></div></p>
<h3 id="DCL操作："><a href="#DCL操作：" class="headerlink" title="DCL操作："></a>DCL操作：</h3><p>&emsp;&emsp;<strong>创建用户：</strong><br><div class="highlight-box"autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false" contenteditable="true"data-rel="PLAIN"><figure class="iseeu highlight /plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br></pre></td><td class="code"><pre><span class="line">//只要是写用户名的位置都可以设置固定ip，或者不固定ip</span><br><span class="line">CREATE USER 用户名@IP地址 IDENTIFIED BY &apos;密码&apos;;//固定ip登录</span><br><span class="line">CREATE USER 用户名@&apos;%&apos; IDENTIFIED BY &apos;密码&apos;;//任意ip登录</span><br><span class="line">CREATE USER zhangSan@&apos;%&apos; IDENTIFIED BY &apos;123&apos;;</span><br></pre></td></tr></table></figure></div></p>
<p>&emsp;&emsp;<strong>给用户授权：</strong><br><div class="highlight-box"autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false" contenteditable="true"data-rel="PLAIN"><figure class="iseeu highlight /plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br></pre></td><td class="code"><pre><span class="line">GRANT 权限1,权限2,...,权限n ON 数据库名称.* TO 用户名@ip地址;</span><br><span class="line">GRANT 权限1,权限2,...,权限n ON 数据库名称.* TO 用户名@&apos;%&apos;;</span><br><span class="line"></span><br><span class="line">GRANT CREATE,ALTER,DROP,INSERT,UPDATE,DELETE,SELECT ON school.* TO zhangSan@&apos;%&apos;;</span><br><span class="line">//给所有权限</span><br><span class="line">GRANT ALL ON school.* TO zhangSan@&apos;%&apos;;</span><br></pre></td></tr></table></figure></div></p>
<p>&emsp;&emsp;<strong>撤销权限：</strong><br><div class="highlight-box"autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false" contenteditable="true"data-rel="PLAIN"><figure class="iseeu highlight /plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">REVOKE  权限1,权限2,...,权限n ON 数据库名称.* FROM 用户名@&apos;%&apos;;</span><br></pre></td></tr></table></figure></div></p>
<p>&emsp;&emsp;<strong>查看用户权限：</strong><br><div class="highlight-box"autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false" contenteditable="true"data-rel="PLAIN"><figure class="iseeu highlight /plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">SHOW GRANTS FOR 用户名@ip地址;</span><br></pre></td></tr></table></figure></div></p>
<p>&emsp;&emsp;<strong>删除用户：</strong><br><div class="highlight-box"autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false" contenteditable="true"data-rel="PLAIN"><figure class="iseeu highlight /plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">DROP USER 用户名@ip地址;</span><br></pre></td></tr></table></figure></div></p>

      
    </div>
    
      <footer class="article-footer">
        完
      </footer>
    
  </div>
  
    
<nav id="article-nav">
  <div class="article-nav-block">
    
      <a href="/2018/10/11/MySQL数据库操作（二）——DQL/" id="article-nav-newer" class="article-nav-link-wrap">
        <strong class="article-nav-caption"></strong>
        <div class="article-nav-title">
          
            MySQL数据库操作（二）——DQL
          
        </div>
      </a>
    
  </div>
  <div class="article-nav-block">
    
      <a href="/2018/05/13/Android——MQTT推送/" id="article-nav-older" class="article-nav-link-wrap">
        <div class="article-nav-title">Android——MQTT推送</div>
        <strong class="article-nav-caption"></strong>
      </a>
    
  </div>
</nav>

    
  
  
</article>
</section>
        <aside id="sidebar">
  
    <div class="widget-box">
  <div class="avatar-box avatar-item">
    <img class="avatar" src="/uploads/artistic_image/head.jpg" title="头像来自网络"></img>
    <h3 class="avatar-name">
      
        海晨忆
      
    </h3>
    <p class="avatar-slogan">
      先谋生，再谋爱。人间值得，未来可期。
    </p>
  </div>
</div>


  
    
  <div class="widget-box">
    <h3 class="widget-title">分类</h3>
    <div class="widget">
      <ul class="category-list"><li class="category-list-item"><a class="category-list-link" href="/categories/Android-Socket/">Android -Socket</a></li><li class="category-list-item"><a class="category-list-link" href="/categories/Android-加密算法/">Android -加密算法</a></li><li class="category-list-item"><a class="category-list-link" href="/categories/Android-常用功能/">Android -常用功能</a></li><li class="category-list-item"><a class="category-list-link" href="/categories/Android-框架/">Android -框架</a></li><li class="category-list-item"><a class="category-list-link" href="/categories/Android-源码解析/">Android -源码解析</a></li><li class="category-list-item"><a class="category-list-link" href="/categories/Android-自定义view/">Android -自定义view</a></li><li class="category-list-item"><a class="category-list-link" href="/categories/Android-设计模式/">Android -设计模式</a></li><li class="category-list-item"><a class="category-list-link" href="/categories/JAVA-并发/">JAVA -并发</a></li><li class="category-list-item"><a class="category-list-link" href="/categories/Java-SpringBoot/">Java -SpringBoot</a></li><li class="category-list-item"><a class="category-list-link" href="/categories/Tomcat/">Tomcat</a></li><li class="category-list-item"><a class="category-list-link" href="/categories/kotlin/">kotlin</a></li><li class="category-list-item"><a class="category-list-link" href="/categories/数据库-JDBC/">数据库 -JDBC</a></li><li class="category-list-item"><a class="category-list-link" href="/categories/数据库-MySQL/">数据库 -MySQL</a></li></ul>
    </div>
  </div>


  
    

  
    
  
    
  <div class="widget-box">
    <h3 class="widget-title">归档</h3>
    <div class="widget">
      <ul class="archive-list"><li class="archive-list-item"><a class="archive-list-link" href="/archives/2021/07/">July 2021</a></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/11/">November 2019</a></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/10/">October 2019</a></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/09/">September 2019</a></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/08/">August 2019</a></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/07/">July 2019</a></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/06/">June 2019</a></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2018/10/">October 2018</a></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2018/05/">May 2018</a></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2018/03/">March 2018</a></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2018/02/">February 2018</a></li></ul>
    </div>
  </div>

  
    
  <div class="widget-box">
    <h3 class="widget-title">最新文章</h3>
    <div class="widget">
      <ul>
        
          <li>
            <a href="/2021/07/27/JAVA—公平锁，非公平锁，悲观锁，乐观锁，死锁/">JAVA—公平锁，非公平锁，悲观锁，乐观锁，死锁</a>
          </li>
        
          <li>
            <a href="/2021/07/19/JAVA—线程同步器AQS/">JAVA—线程同步器AQS</a>
          </li>
        
          <li>
            <a href="/2021/07/07/Android模拟点击/">Android模拟点击</a>
          </li>
        
          <li>
            <a href="/2019/11/27/SpringBoot系列-消息-RabbitMQ-（二十）/">SpringBoot系列-消息(RabbitMQ)（二十）</a>
          </li>
        
          <li>
            <a href="/2019/11/13/SpringBoot系列-Docker（十九）/">SpringBoot系列-Docker（十九）</a>
          </li>
        
      </ul>
    </div>
  </div>

  
      <div class="widget-box">
    <h3 class="widget-title">友情链接</h3>
    <div class="widget">
      
        <a class="hrf" style="display: block;" href="https://github.com/haichenyi" title target='_blank'
        >Github</a>
      
        <a class="hrf" style="display: block;" href="https://www.jianshu.com/u/6077ee440c37" title target='_blank'
        >简书</a>
      
        <a class="hrf" style="display: block;" href="https://blog.csdn.net/qq_27634797" title target='_blank'
        >CSDN</a>
      
    </div>
  </div>

  
</aside>
      </div>
      <footer id="footer">
  <div class="foot-box footers global-width">
    &copy;2017-2021 海晨忆 &nbsp;&nbsp;
    <script async src="//busuanzi.ibruce.info/busuanzi/2.3/busuanzi.pure.mini.js"></script>
    <span id="busuanzi_container_site_pv">阁下是第<span id="busuanzi_value_site_pv"></span>个访客</span>
  </div>
</footer>
      <script src="https://code.jquery.com/jquery-2.0.3.min.js"></script>
<script>
if (!window.jQuery) {
var script = document.createElement('script');
script.src = "/js/jquery-2.0.3.min.js";
document.body.write(script);
}
</script>

  <link rel="stylesheet" href="/fancybox/jquery.fancybox.css">
  <script src="/fancybox/jquery.fancybox.pack.js"></script>


<script src="/js/script.js"></script>



    </div>
    <nav id="mobile-nav" class="mobile-nav-box">
  <div class="mobile-nav-img mobile-nav-top"></div>
  
    <a href="/" class="mobile-nav-link">首页</a>
  
    <a href="/archives" class="mobile-nav-link">归档</a>
  
    <a href="/about" class="mobile-nav-link">简历</a>
  
  <div class="mobile-nav-img  mobile-nav-bottom"></div>
</nav>    
  </div>
</body>
</html>